Add OLAP parameter

To add OLAP parameter:

 

·          Select Query name inside Workspace

·          Right click

·          Select Add from menu

·          Select New Parameter from submenu

 

 

Dialog form will appear:

 

 

Now you have to define your parameter:

 

·          Select tab Mdx command

·          Select part of MDX you want to replace (we will select

                                   [Time].[Calendar].[Year].MEMBERS

 

 

Your selection will appear in a lower part of the form:

 

 

You have to select exact portion of the MDX. CubePlayer will control that.

If you did not select correct part Select button will not be enabled.

 

To enable selection of levels and members:

 

·          Select Allow extended level and member selection

·          Select Select button

 

You will be switched back to tab General.

 

 

Now:

 

·          Add name

·          Add comment if you want

·          Select other elements (in our case we will leave default)

·          Select Accept

 

Parameter will appear: